Overview
Brought to you by YData
Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 45376 |
| Missing cells | 41134 |
| Missing cells (%) | 4.5% |
| Duplicate rows | 16 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 55.6 MiB |
| Average record size in memory | 1.3 KiB |
Variable types
| Numeric | 9 |
|---|---|
| Text | 4 |
| DateTime | 1 |
| Unsupported | 5 |
| Categorical | 1 |
| Dataset has 16 (< 0.1%) duplicate rows | Duplicates |
budget is highly overall correlated with return and 1 other fields | High correlation |
popularity is highly overall correlated with vote_count | High correlation |
return is highly overall correlated with budget and 1 other fields | High correlation |
revenue is highly overall correlated with budget and 2 other fields | High correlation |
vote_count is highly overall correlated with popularity and 1 other fields | High correlation |
status is highly imbalanced (96.6%) | Imbalance |
belongs_to_collection has 40888 (90.1%) missing values | Missing |
popularity is highly skewed (γ1 = 29.21506573) | Skewed |
return is highly skewed (γ1 = 138.3295261) | Skewed |
genres is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
production_companies is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
production_countries is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
spoken_languages is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
belongs_to_collection is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
runtime has 1535 (3.4%) zeros | Zeros |
budget has 36490 (80.4%) zeros | Zeros |
revenue has 37969 (83.7%) zeros | Zeros |
vote_average has 2947 (6.5%) zeros | Zeros |
vote_count has 2849 (6.3%) zeros | Zeros |
return has 40057 (88.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-18 17:13:37.062245 |
|---|---|
| Analysis finished | 2025-02-18 17:14:24.951472 |
| Duration | 47.89 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
movie_id
Real number (ℝ)
| Distinct | 45346 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 108027.1 |
| Minimum | 2 |
|---|---|
| Maximum | 469172 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 5348.75 |
| Q1 | 26385.75 |
| median | 59857.5 |
| Q3 | 156533.5 |
| 95-th percentile | 357194.5 |
| Maximum | 469172 |
| Range | 469170 |
| Interquartile range (IQR) | 130147.75 |
Descriptive statistics
| Standard deviation | 112168.38 |
|---|---|
| Coefficient of variation (CV) | 1.0383355 |
| Kurtosis | 0.55951556 |
| Mean | 108027.1 |
| Median Absolute Deviation (MAD) | 44418.5 |
| Skewness | 1.2830689 |
| Sum | 4.9018378 × 109 |
| Variance | 1.2581745 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 141971 | 3 | < 0.1% |
| 97995 | 2 | < 0.1% |
| 10991 | 2 | < 0.1% |
| 109962 | 2 | < 0.1% |
| 119916 | 2 | < 0.1% |
| 159849 | 2 | < 0.1% |
| 84198 | 2 | < 0.1% |
| 132641 | 2 | < 0.1% |
| 168538 | 2 | < 0.1% |
| 99080 | 2 | < 0.1% |
| Other values (45336) | 45355 |
| Value | Count | Frequency (%) |
| 2 | 1 | |
| 3 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 11 | 1 | |
| 12 | 1 | |
| 13 | 1 | |
| 14 | 1 | |
| 15 | 1 | |
| 16 | 1 |
| Value | Count | Frequency (%) |
| 469172 | 1 | |
| 468707 | 1 | |
| 468343 | 1 | |
| 467731 | 1 | |
| 465044 | 1 | |
| 464819 | 1 | |
| 464207 | 1 | |
| 464111 | 1 | |
| 463906 | 1 | |
| 463800 | 1 |
title
Text
| Distinct | 42196 |
|---|---|
| Distinct (%) | 93.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
Length
| Max length | 105 |
|---|---|
| Median length | 79 |
| Mean length | 16.701781 |
| Min length | 1 |
Unique
| Unique | 39869 ? |
|---|---|
| Unique (%) | 87.9% |
Sample
| 1st row | Toy Story |
|---|---|
| 2nd row | Jumanji |
| 3rd row | Grumpier Old Men |
| 4th row | Waiting to Exhale |
| 5th row | Father of the Bride Part II |
| Value | Count | Frequency (%) |
| the | 14555 | 10.7% |
| of | 4930 | 3.6% |
| a | 2241 | 1.6% |
| in | 1693 | 1.2% |
| and | 1631 | 1.2% |
| to | 1054 | 0.8% |
| 757 | 0.6% | |
| man | 665 | 0.5% |
| love | 664 | 0.5% |
| for | 601 | 0.4% |
| Other values (24353) | 107390 |
Most occurring characters
| Value | Count | Frequency (%) |
| 90827 | 12.0% | |
| e | 76251 | 10.1% |
| a | 48940 | 6.5% |
| o | 45671 | 6.0% |
| n | 40817 | 5.4% |
| r | 40018 | 5.3% |
| i | 39764 | 5.2% |
| t | 36722 | 4.8% |
| s | 29519 | 3.9% |
| h | 28516 | 3.8% |
| Other values (277) | 280815 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 757860 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 90827 | 12.0% | |
| e | 76251 | 10.1% |
| a | 48940 | 6.5% |
| o | 45671 | 6.0% |
| n | 40817 | 5.4% |
| r | 40018 | 5.3% |
| i | 39764 | 5.2% |
| t | 36722 | 4.8% |
| s | 29519 | 3.9% |
| h | 28516 | 3.8% |
| Other values (277) | 280815 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 757860 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 90827 | 12.0% | |
| e | 76251 | 10.1% |
| a | 48940 | 6.5% |
| o | 45671 | 6.0% |
| n | 40817 | 5.4% |
| r | 40018 | 5.3% |
| i | 39764 | 5.2% |
| t | 36722 | 4.8% |
| s | 29519 | 3.9% |
| h | 28516 | 3.8% |
| Other values (277) | 280815 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 757860 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 90827 | 12.0% | |
| e | 76251 | 10.1% |
| a | 48940 | 6.5% |
| o | 45671 | 6.0% |
| n | 40817 | 5.4% |
| r | 40018 | 5.3% |
| i | 39764 | 5.2% |
| t | 36722 | 4.8% |
| s | 29519 | 3.9% |
| h | 28516 | 3.8% |
| Other values (277) | 280815 |
tagline
Text
| Distinct | 20270 |
|---|---|
| Distinct (%) | 44.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.5 MiB |
Length
| Max length | 297 |
|---|---|
| Median length | 3 |
| Mean length | 22.779134 |
| Min length | 1 |
Unique
| Unique | 20163 ? |
|---|---|
| Unique (%) | 44.4% |
Sample
| 1st row | nan |
|---|---|
| 2nd row | Roll the dice and unleash the excitement! |
| 3rd row | Still Yelling. Still Fighting. Still Ready for Love. |
| 4th row | Friends are the people who let you be yourself... and never let you forget it. |
| 5th row | Just When His World Is Back To Normal... He's In For The Surprise Of His Life! |
| Value | Count | Frequency (%) |
| nan | 24978 | 12.6% |
| the | 10998 | 5.5% |
| a | 6815 | 3.4% |
| of | 4404 | 2.2% |
| to | 3584 | 1.8% |
| is | 2796 | 1.4% |
| in | 2693 | 1.4% |
| and | 2682 | 1.3% |
| you | 2389 | 1.2% |
| 1582 | 0.8% | |
| Other values (15101) | 135993 |
Most occurring characters
| Value | Count | Frequency (%) |
| 153686 | ||
| n | 97454 | 9.4% |
| e | 94412 | 9.1% |
| a | 76451 | 7.4% |
| t | 57267 | 5.5% |
| o | 56566 | 5.5% |
| i | 46036 | 4.5% |
| r | 44992 | 4.4% |
| s | 42360 | 4.1% |
| h | 37172 | 3.6% |
| Other values (160) | 327230 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1033626 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 153686 | ||
| n | 97454 | 9.4% |
| e | 94412 | 9.1% |
| a | 76451 | 7.4% |
| t | 57267 | 5.5% |
| o | 56566 | 5.5% |
| i | 46036 | 4.5% |
| r | 44992 | 4.4% |
| s | 42360 | 4.1% |
| h | 37172 | 3.6% |
| Other values (160) | 327230 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1033626 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 153686 | ||
| n | 97454 | 9.4% |
| e | 94412 | 9.1% |
| a | 76451 | 7.4% |
| t | 57267 | 5.5% |
| o | 56566 | 5.5% |
| i | 46036 | 4.5% |
| r | 44992 | 4.4% |
| s | 42360 | 4.1% |
| h | 37172 | 3.6% |
| Other values (160) | 327230 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1033626 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 153686 | ||
| n | 97454 | 9.4% |
| e | 94412 | 9.1% |
| a | 76451 | 7.4% |
| t | 57267 | 5.5% |
| o | 56566 | 5.5% |
| i | 46036 | 4.5% |
| r | 44992 | 4.4% |
| s | 42360 | 4.1% |
| h | 37172 | 3.6% |
| Other values (160) | 327230 |
release_date
Date
| Distinct | 17333 |
|---|---|
| Distinct (%) | 38.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 354.6 KiB |
| Minimum | 1874-12-09 00:00:00 |
|---|---|
| Maximum | 2020-12-16 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
release_year
Real number (ℝ)
| Distinct | 135 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1991.8812 |
| Minimum | 1874 |
|---|---|
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 1874 |
|---|---|
| 5-th percentile | 1941 |
| Q1 | 1978 |
| median | 2001 |
| Q3 | 2010 |
| 95-th percentile | 2015 |
| Maximum | 2020 |
| Range | 146 |
| Interquartile range (IQR) | 32 |
Descriptive statistics
| Standard deviation | 24.05536 |
|---|---|
| Coefficient of variation (CV) | 0.012076704 |
| Kurtosis | 0.84010576 |
| Mean | 1991.8812 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -1.2248636 |
| Sum | 90383601 |
| Variance | 578.66033 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2014 | 1974 | 4.4% |
| 2015 | 1905 | 4.2% |
| 2013 | 1889 | 4.2% |
| 2012 | 1722 | 3.8% |
| 2011 | 1667 | 3.7% |
| 2016 | 1604 | 3.5% |
| 2009 | 1586 | 3.5% |
| 2010 | 1501 | 3.3% |
| 2008 | 1473 | 3.2% |
| 2007 | 1320 | 2.9% |
| Other values (125) | 28735 |
| Value | Count | Frequency (%) |
| 1874 | 1 | < 0.1% |
| 1878 | 1 | < 0.1% |
| 1883 | 1 | < 0.1% |
| 1887 | 1 | < 0.1% |
| 1888 | 2 | < 0.1% |
| 1890 | 5 | < 0.1% |
| 1891 | 6 | |
| 1892 | 3 | < 0.1% |
| 1893 | 1 | < 0.1% |
| 1894 | 13 |
| Value | Count | Frequency (%) |
| 2020 | 1 | < 0.1% |
| 2018 | 5 | < 0.1% |
| 2017 | 532 | 1.2% |
| 2016 | 1604 | |
| 2015 | 1905 | |
| 2014 | 1974 | |
| 2013 | 1889 | |
| 2012 | 1722 | |
| 2011 | 1667 | |
| 2010 | 1501 |
runtime
Real number (ℝ)
Zeros 
| Distinct | 353 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 246 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.181675 |
| Minimum | 0 |
|---|---|
| Maximum | 1256 |
| Zeros | 1535 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 85 |
| median | 95 |
| Q3 | 107 |
| 95-th percentile | 138 |
| Maximum | 1256 |
| Range | 1256 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 38.341059 |
|---|---|
| Coefficient of variation (CV) | 0.4070968 |
| Kurtosis | 93.925543 |
| Mean | 94.181675 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 4.4907363 |
| Sum | 4250419 |
| Variance | 1470.0368 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 2549 | 5.6% |
| 0 | 1535 | 3.4% |
| 100 | 1470 | 3.2% |
| 95 | 1410 | 3.1% |
| 93 | 1214 | 2.7% |
| 96 | 1104 | 2.4% |
| 92 | 1079 | 2.4% |
| 94 | 1062 | 2.3% |
| 91 | 1055 | 2.3% |
| 88 | 1030 | 2.3% |
| Other values (343) | 31622 |
| Value | Count | Frequency (%) |
| 0 | 1535 | |
| 1 | 107 | 0.2% |
| 2 | 33 | 0.1% |
| 3 | 48 | 0.1% |
| 4 | 50 | 0.1% |
| 5 | 51 | 0.1% |
| 6 | 72 | 0.2% |
| 7 | 103 | 0.2% |
| 8 | 78 | 0.2% |
| 9 | 63 | 0.1% |
| Value | Count | Frequency (%) |
| 1256 | 1 | |
| 1140 | 2 | |
| 931 | 1 | |
| 925 | 1 | |
| 900 | 1 | |
| 877 | 1 | |
| 874 | 1 | |
| 840 | 2 | |
| 780 | 1 | |
| 720 | 1 |
budget
Real number (ℝ)
High correlation  Zeros 
| Distinct | 1223 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4232604.4 |
| Minimum | 0 |
|---|---|
| Maximum | 3.8 × 108 |
| Zeros | 36490 |
| Zeros (%) | 80.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 25000000 |
| Maximum | 3.8 × 108 |
| Range | 3.8 × 108 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 17439860 |
|---|---|
| Coefficient of variation (CV) | 4.1203614 |
| Kurtosis | 66.634491 |
| Mean | 4232604.4 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.1183385 |
| Sum | 1.9205866 × 1011 |
| Variance | 3.041487 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 36490 | |
| 5000000 | 286 | 0.6% |
| 10000000 | 259 | 0.6% |
| 20000000 | 243 | 0.5% |
| 2000000 | 242 | 0.5% |
| 15000000 | 226 | 0.5% |
| 3000000 | 223 | 0.5% |
| 25000000 | 206 | 0.5% |
| 1000000 | 197 | 0.4% |
| 30000000 | 190 | 0.4% |
| Other values (1213) | 6814 | 15.0% |
| Value | Count | Frequency (%) |
| 0 | 36490 | |
| 1 | 25 | 0.1% |
| 2 | 14 | < 0.1% |
| 3 | 9 | < 0.1% |
| 4 | 8 | < 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 5 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 380000000 | 1 | < 0.1% |
| 300000000 | 1 | < 0.1% |
| 280000000 | 1 | < 0.1% |
| 270000000 | 1 | < 0.1% |
| 260000000 | 3 | < 0.1% |
| 258000000 | 1 | < 0.1% |
| 255000000 | 1 | < 0.1% |
| 250000000 | 10 | |
| 245000000 | 2 | < 0.1% |
| 237000000 | 1 | < 0.1% |
revenue
Real number (ℝ)
High correlation  Zeros 
| Distinct | 6863 |
|---|---|
| Distinct (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11230099 |
| Minimum | 0 |
|---|---|
| Maximum | 2.7879651 × 109 |
| Zeros | 37969 |
| Zeros (%) | 83.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 48020044 |
| Maximum | 2.7879651 × 109 |
| Range | 2.7879651 × 109 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 64389957 |
|---|---|
| Coefficient of variation (CV) | 5.7336944 |
| Kurtosis | 237.07741 |
| Mean | 11230099 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.254722 |
| Sum | 5.0957698 × 1011 |
| Variance | 4.1460665 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37969 | |
| 12000000 | 20 | < 0.1% |
| 10000000 | 19 | < 0.1% |
| 11000000 | 19 | < 0.1% |
| 2000000 | 18 | < 0.1% |
| 6000000 | 17 | < 0.1% |
| 5000000 | 14 | < 0.1% |
| 8000000 | 13 | < 0.1% |
| 500000 | 13 | < 0.1% |
| 1 | 12 | < 0.1% |
| Other values (6853) | 7262 | 16.0% |
| Value | Count | Frequency (%) |
| 0 | 37969 | |
| 1 | 12 | < 0.1% |
| 2 | 3 | < 0.1% |
| 3 | 9 | < 0.1% |
| 4 | 4 | < 0.1% |
| 5 | 5 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2787965087 | 1 | |
| 2068223624 | 1 | |
| 1845034188 | 1 | |
| 1519557910 | 1 | |
| 1513528810 | 1 | |
| 1506249360 | 1 | |
| 1405403694 | 1 | |
| 1342000000 | 1 | |
| 1274219009 | 1 | |
| 1262886337 | 1 |
genres
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
production_companies
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
production_countries
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
spoken_languages
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.0002424 |
| Min length | 2 |
Unique
| Unique | 17 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | en |
|---|---|
| 2nd row | en |
| 3rd row | en |
| 4th row | en |
| 5th row | en |
| Value | Count | Frequency (%) |
| en | 32202 | |
| fr | 2437 | 5.4% |
| it | 1528 | 3.4% |
| ja | 1349 | 3.0% |
| de | 1078 | 2.4% |
| es | 992 | 2.2% |
| ru | 822 | 1.8% |
| hi | 508 | 1.1% |
| ko | 444 | 1.0% |
| zh | 408 | 0.9% |
| Other values (80) | 3608 | 8.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 34527 | |
| n | 32932 | |
| r | 3630 | 4.0% |
| f | 2835 | 3.1% |
| i | 2388 | 2.6% |
| t | 2250 | 2.5% |
| a | 1850 | 2.0% |
| s | 1652 | 1.8% |
| j | 1350 | 1.5% |
| d | 1323 | 1.5% |
| Other values (16) | 6026 | 6.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 90763 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 34527 | |
| n | 32932 | |
| r | 3630 | 4.0% |
| f | 2835 | 3.1% |
| i | 2388 | 2.6% |
| t | 2250 | 2.5% |
| a | 1850 | 2.0% |
| s | 1652 | 1.8% |
| j | 1350 | 1.5% |
| d | 1323 | 1.5% |
| Other values (16) | 6026 | 6.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 90763 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 34527 | |
| n | 32932 | |
| r | 3630 | 4.0% |
| f | 2835 | 3.1% |
| i | 2388 | 2.6% |
| t | 2250 | 2.5% |
| a | 1850 | 2.0% |
| s | 1652 | 1.8% |
| j | 1350 | 1.5% |
| d | 1323 | 1.5% |
| Other values (16) | 6026 | 6.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 90763 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 34527 | |
| n | 32932 | |
| r | 3630 | 4.0% |
| f | 2835 | 3.1% |
| i | 2388 | 2.6% |
| t | 2250 | 2.5% |
| a | 1850 | 2.0% |
| s | 1652 | 1.8% |
| j | 1350 | 1.5% |
| d | 1323 | 1.5% |
| Other values (16) | 6026 | 6.6% |
overview
Text
| Distinct | 44233 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.0 MiB |
Length
| Max length | 1000 |
|---|---|
| Median length | 790 |
| Mean length | 316.6548 |
| Min length | 1 |
Unique
| Unique | 44173 ? |
|---|---|
| Unique (%) | 97.3% |
Sample
| 1st row | Led by Woody, Andy's toys live happily in his room until Andy's birthday brings Buzz Lightyear onto the scene. Afraid of losing his place in Andy's heart, Woody plots against Buzz. But when circumstances separate Buzz and Woody from their owner, the duo eventually learns to put aside their differences. |
|---|---|
| 2nd row | When siblings Judy and Peter discover an enchanted board game that opens the door to a magical world, they unwittingly invite Alan -- an adult who's been trapped inside the game for 26 years -- into their living room. Alan's only hope for freedom is to finish the game, which proves risky as all three find themselves running from giant rhinoceroses, evil monkeys and other terrifying creatures. |
| 3rd row | A family wedding reignites the ancient feud between next-door neighbors and fishing buddies John and Max. Meanwhile, a sultry Italian divorcée opens a restaurant at the local bait shop, alarming the locals who worry she'll scare the fish away. But she's less interested in seafood than she is in cooking up a hot time with Max. |
| 4th row | Cheated on, mistreated and stepped on, the women are holding their breath, waiting for the elusive "good man" to break a string of less-than-stellar lovers. Friends and confidants Vannah, Bernie, Glo and Robin talk it all out, determined to find a better way to breathe. |
| 5th row | Just when George Banks has recovered from his daughter's wedding, he receives the news that she's pregnant ... and that George's wife, Nina, is expecting too. He was planning on selling their home, but that's a plan that -- like George -- will have to change with the arrival of both a grandchild and a kid of his own. |
| Value | Count | Frequency (%) |
| the | 138082 | 5.6% |
| a | 98889 | 4.0% |
| and | 75259 | 3.1% |
| to | 73321 | 3.0% |
| of | 69574 | 2.8% |
| in | 48143 | 2.0% |
| is | 36500 | 1.5% |
| his | 36165 | 1.5% |
| with | 23902 | 1.0% |
| her | 21484 | 0.9% |
| Other values (97091) | 1828330 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2406350 | ||
| e | 1363787 | 9.5% |
| a | 941443 | 6.6% |
| t | 934766 | 6.5% |
| i | 851514 | 5.9% |
| o | 829873 | 5.8% |
| n | 824483 | 5.7% |
| s | 767851 | 5.3% |
| r | 744274 | 5.2% |
| h | 600810 | 4.2% |
| Other values (419) | 4103377 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14368528 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2406350 | ||
| e | 1363787 | 9.5% |
| a | 941443 | 6.6% |
| t | 934766 | 6.5% |
| i | 851514 | 5.9% |
| o | 829873 | 5.8% |
| n | 824483 | 5.7% |
| s | 767851 | 5.3% |
| r | 744274 | 5.2% |
| h | 600810 | 4.2% |
| Other values (419) | 4103377 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14368528 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2406350 | ||
| e | 1363787 | 9.5% |
| a | 941443 | 6.6% |
| t | 934766 | 6.5% |
| i | 851514 | 5.9% |
| o | 829873 | 5.8% |
| n | 824483 | 5.7% |
| s | 767851 | 5.3% |
| r | 744274 | 5.2% |
| h | 600810 | 4.2% |
| Other values (419) | 4103377 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14368528 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2406350 | ||
| e | 1363787 | 9.5% |
| a | 941443 | 6.6% |
| t | 934766 | 6.5% |
| i | 851514 | 5.9% |
| o | 829873 | 5.8% |
| n | 824483 | 5.7% |
| s | 767851 | 5.3% |
| r | 744274 | 5.2% |
| h | 600810 | 4.2% |
| Other values (419) | 4103377 |
popularity
Real number (ℝ)
High correlation  Skewed 
| Distinct | 43731 |
|---|---|
| Distinct (%) | 96.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9264576 |
| Minimum | 0 |
|---|---|
| Maximum | 547.4883 |
| Zeros | 40 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.02079775 |
| Q1 | 0.3888395 |
| median | 1.1304545 |
| Q3 | 3.6916945 |
| 95-th percentile | 11.063627 |
| Maximum | 547.4883 |
| Range | 547.4883 |
| Interquartile range (IQR) | 3.302855 |
Descriptive statistics
| Standard deviation | 6.0096718 |
|---|---|
| Coefficient of variation (CV) | 2.0535653 |
| Kurtosis | 1923.6882 |
| Mean | 2.9264576 |
| Median Absolute Deviation (MAD) | 0.9676215 |
| Skewness | 29.215066 |
| Sum | 132790.94 |
| Variance | 36.116156 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 × 10-6 | 56 | 0.1% |
| 0.000308 | 42 | 0.1% |
| 0 | 40 | 0.1% |
| 0.00022 | 39 | 0.1% |
| 0.000844 | 38 | 0.1% |
| 0.000578 | 38 | 0.1% |
| 0.001177 | 38 | 0.1% |
| 0.002001 | 27 | 0.1% |
| 0.003013 | 21 | < 0.1% |
| 0.00353 | 19 | < 0.1% |
| Other values (43721) | 45018 |
| Value | Count | Frequency (%) |
| 0 | 40 | |
| 1 × 10-6 | 56 | |
| 2 × 10-6 | 6 | < 0.1% |
| 3 × 10-6 | 6 | < 0.1% |
| 4 × 10-6 | 5 | < 0.1% |
| 5 × 10-6 | 1 | < 0.1% |
| 6 × 10-6 | 2 | < 0.1% |
| 7 × 10-6 | 1 | < 0.1% |
| 8 × 10-6 | 6 | < 0.1% |
| 9 × 10-6 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 547.488298 | 1 | |
| 294.337037 | 1 | |
| 287.253654 | 1 | |
| 228.032744 | 1 | |
| 213.849907 | 1 | |
| 187.860492 | 1 | |
| 185.330992 | 1 | |
| 185.070892 | 1 | |
| 183.870374 | 1 | |
| 154.801009 | 1 |
vote_average
Real number (ℝ)
Zeros 
| Distinct | 92 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.62407 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 2947 |
| Zeros (%) | 6.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5 |
| median | 6 |
| Q3 | 6.8 |
| 95-th percentile | 7.8 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 1.8 |
Descriptive statistics
| Standard deviation | 1.9154225 |
|---|---|
| Coefficient of variation (CV) | 0.34057587 |
| Kurtosis | 2.5420547 |
| Mean | 5.62407 |
| Median Absolute Deviation (MAD) | 0.9 |
| Skewness | -1.524472 |
| Sum | 255197.8 |
| Variance | 3.6688434 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2947 | 6.5% |
| 6 | 2462 | 5.4% |
| 5 | 1998 | 4.4% |
| 7 | 1883 | 4.1% |
| 6.5 | 1722 | 3.8% |
| 6.3 | 1603 | 3.5% |
| 5.5 | 1381 | 3.0% |
| 5.8 | 1369 | 3.0% |
| 6.4 | 1350 | 3.0% |
| 6.7 | 1342 | 3.0% |
| Other values (82) | 27319 |
| Value | Count | Frequency (%) |
| 0 | 2947 | |
| 0.5 | 13 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 1 | 103 | 0.2% |
| 1.1 | 1 | < 0.1% |
| 1.2 | 4 | < 0.1% |
| 1.3 | 13 | < 0.1% |
| 1.4 | 5 | < 0.1% |
| 1.5 | 30 | 0.1% |
| 1.6 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 185 | |
| 9.8 | 1 | < 0.1% |
| 9.6 | 1 | < 0.1% |
| 9.5 | 18 | < 0.1% |
| 9.4 | 3 | < 0.1% |
| 9.3 | 18 | < 0.1% |
| 9.2 | 4 | < 0.1% |
| 9.1 | 2 | < 0.1% |
| 9 | 158 | |
| 8.9 | 7 | < 0.1% |
vote_count
Real number (ℝ)
High correlation  Zeros 
| Distinct | 1820 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 110.09644 |
| Minimum | 0 |
|---|---|
| Maximum | 14075 |
| Zeros | 2849 |
| Zeros (%) | 6.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 10 |
| Q3 | 34 |
| 95-th percentile | 434 |
| Maximum | 14075 |
| Range | 14075 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 491.74289 |
|---|---|
| Coefficient of variation (CV) | 4.4664741 |
| Kurtosis | 150.92858 |
| Mean | 110.09644 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 10.440782 |
| Sum | 4995736 |
| Variance | 241811.07 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 3242 | 7.1% |
| 2 | 3127 | 6.9% |
| 0 | 2849 | 6.3% |
| 3 | 2785 | 6.1% |
| 4 | 2478 | 5.5% |
| 5 | 2097 | 4.6% |
| 6 | 1747 | 3.9% |
| 7 | 1570 | 3.5% |
| 8 | 1359 | 3.0% |
| 9 | 1194 | 2.6% |
| Other values (1810) | 22928 |
| Value | Count | Frequency (%) |
| 0 | 2849 | |
| 1 | 3242 | |
| 2 | 3127 | |
| 3 | 2785 | |
| 4 | 2478 | |
| 5 | 2097 | |
| 6 | 1747 | |
| 7 | 1570 | |
| 8 | 1359 | |
| 9 | 1194 | 2.6% |
| Value | Count | Frequency (%) |
| 14075 | 1 | |
| 12269 | 1 | |
| 12114 | 1 | |
| 12000 | 1 | |
| 11444 | 1 | |
| 11187 | 1 | |
| 10297 | 1 | |
| 10014 | 1 | |
| 9678 | 1 | |
| 9634 | 1 |
belongs_to_collection
Unsupported
Missing  Rejected  Unsupported 
| Missing | 40888 |
|---|---|
| Missing (%) | 90.1% |
| Memory size | 2.3 MiB |
status
Categorical
Imbalance 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Released | |
|---|---|
| Rumored | 230 |
| Post Production | 97 |
| nan | 80 |
| In Production | 19 |
| Other values (2) | 14 |
Length
| Max length | 15 |
|---|---|
| Median length | 8 |
| Mean length | 8.002887 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Released |
|---|---|
| 2nd row | Released |
| 3rd row | Released |
| 4th row | Released |
| 5th row | Released |
Common Values
| Value | Count | Frequency (%) |
| Released | 44936 | |
| Rumored | 230 | 0.5% |
| Post Production | 97 | 0.2% |
| nan | 80 | 0.2% |
| In Production | 19 | < 0.1% |
| Planned | 13 | < 0.1% |
| Canceled | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| released | 44936 | |
| rumored | 230 | 0.5% |
| production | 116 | 0.3% |
| post | 97 | 0.2% |
| nan | 80 | 0.2% |
| in | 19 | < 0.1% |
| planned | 13 | < 0.1% |
| canceled | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 135053 | |
| d | 45296 | 12.5% |
| R | 45166 | 12.4% |
| s | 45033 | 12.4% |
| a | 45030 | 12.4% |
| l | 44950 | 12.4% |
| o | 559 | 0.2% |
| r | 346 | 0.1% |
| u | 346 | 0.1% |
| n | 322 | 0.1% |
| Other values (8) | 1038 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 363139 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 135053 | |
| d | 45296 | 12.5% |
| R | 45166 | 12.4% |
| s | 45033 | 12.4% |
| a | 45030 | 12.4% |
| l | 44950 | 12.4% |
| o | 559 | 0.2% |
| r | 346 | 0.1% |
| u | 346 | 0.1% |
| n | 322 | 0.1% |
| Other values (8) | 1038 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 363139 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 135053 | |
| d | 45296 | 12.5% |
| R | 45166 | 12.4% |
| s | 45033 | 12.4% |
| a | 45030 | 12.4% |
| l | 44950 | 12.4% |
| o | 559 | 0.2% |
| r | 346 | 0.1% |
| u | 346 | 0.1% |
| n | 322 | 0.1% |
| Other values (8) | 1038 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 363139 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 135053 | |
| d | 45296 | 12.5% |
| R | 45166 | 12.4% |
| s | 45033 | 12.4% |
| a | 45030 | 12.4% |
| l | 44950 | 12.4% |
| o | 559 | 0.2% |
| r | 346 | 0.1% |
| u | 346 | 0.1% |
| n | 322 | 0.1% |
| Other values (8) | 1038 | 0.3% |
return
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 1256 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 660.04279 |
| Minimum | 0 |
|---|---|
| Maximum | 12396383 |
| Zeros | 40057 |
| Zeros (%) | 88.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 354.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.54 |
| Maximum | 12396383 |
| Range | 12396383 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 74693.294 |
|---|---|
| Coefficient of variation (CV) | 113.16432 |
| Kurtosis | 20672.957 |
| Mean | 660.04279 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 138.32953 |
| Sum | 29950102 |
| Variance | 5.5790882 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 40057 | |
| 0.01 | 64 | 0.1% |
| 0.02 | 38 | 0.1% |
| 1 | 34 | 0.1% |
| 0.08 | 29 | 0.1% |
| 0.06 | 27 | 0.1% |
| 0.03 | 25 | 0.1% |
| 0.62 | 25 | 0.1% |
| 1.1 | 24 | 0.1% |
| 1.2 | 23 | 0.1% |
| Other values (1246) | 5030 | 11.1% |
| Value | Count | Frequency (%) |
| 0 | 40057 | |
| 0.01 | 64 | 0.1% |
| 0.02 | 38 | 0.1% |
| 0.03 | 25 | 0.1% |
| 0.04 | 19 | < 0.1% |
| 0.05 | 22 | < 0.1% |
| 0.06 | 27 | 0.1% |
| 0.07 | 18 | < 0.1% |
| 0.08 | 29 | 0.1% |
| 0.09 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 12396383 | 1 | |
| 8500000 | 1 | |
| 4197476.62 | 1 | |
| 2755584 | 1 | |
| 1018619.28 | 1 | |
| 1000000 | 1 | |
| 26881.72 | 1 | |
| 12890.39 | 1 | |
| 5330.34 | 1 | |
| 4133.33 | 1 |
Interactions
Correlations
| budget | movie_id | popularity | release_year | return | revenue | runtime | status | vote_average | vote_count | |
|---|---|---|---|---|---|---|---|---|---|---|
| budget | 1.000 | -0.255 | 0.463 | 0.141 | 0.771 | 0.644 | 0.227 | 0.000 | 0.072 | 0.484 |
| movie_id | -0.255 | 1.000 | -0.410 | 0.392 | -0.263 | -0.278 | -0.205 | 0.053 | -0.149 | -0.433 |
| popularity | 0.463 | -0.410 | 1.000 | 0.186 | 0.446 | 0.491 | 0.307 | 0.000 | 0.241 | 0.893 |
| release_year | 0.141 | 0.392 | 0.186 | 1.000 | 0.085 | 0.104 | 0.034 | 0.027 | -0.009 | 0.197 |
| return | 0.771 | -0.263 | 0.446 | 0.085 | 1.000 | 0.849 | 0.234 | 0.000 | 0.121 | 0.473 |
| revenue | 0.644 | -0.278 | 0.491 | 0.104 | 0.849 | 1.000 | 0.254 | 0.000 | 0.127 | 0.513 |
| runtime | 0.227 | -0.205 | 0.307 | 0.034 | 0.234 | 0.254 | 1.000 | 0.000 | 0.193 | 0.290 |
| status | 0.000 | 0.053 | 0.000 | 0.027 | 0.000 | 0.000 | 0.000 | 1.000 | 0.025 | 0.000 |
| vote_average | 0.072 | -0.149 | 0.241 | -0.009 | 0.121 | 0.127 | 0.193 | 0.025 | 1.000 | 0.318 |
| vote_count | 0.484 | -0.433 | 0.893 | 0.197 | 0.473 | 0.513 | 0.290 | 0.000 | 0.318 | 1.000 |
Missing values
Sample
| movie_id | title | tagline | release_date | release_year | runtime | budget | revenue | genres | production_companies | production_countries | spoken_languages | original_language | overview | popularity | vote_average | vote_count | belongs_to_collection | status | return | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 862 | Toy Story | nan | 1995-10-30 | 1995 | 81.0 | 30000000 | 373554033 | [{'id': 16, 'name': 'Animation'}, {'id': 35, 'name': 'Comedy'}, {'id': 10751, 'name': 'Family'}] | [{'name': 'Pixar Animation Studios', 'id': 3}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | Led by Woody, Andy's toys live happily in his room until Andy's birthday brings Buzz Lightyear onto the scene. Afraid of losing his place in Andy's heart, Woody plots against Buzz. But when circumstances separate Buzz and Woody from their owner, the duo eventually learns to put aside their differences. | 21.946943 | 7.7 | 5415.0 | {'id': 10194, 'name': 'Toy Story Collection', 'poster_path': '/7G9915LfUQ2lVfwMEEhDsn3kT4B.jpg', 'backdrop_path': '/9FBwqcd9IRruEDUrTdcaafOMKUq.jpg'} | Released | 12.45 |
| 1 | 8844 | Jumanji | Roll the dice and unleash the excitement! | 1995-12-15 | 1995 | 104.0 | 65000000 | 262797249 | [{'id': 12, 'name': 'Adventure'}, {'id': 14, 'name': 'Fantasy'}, {'id': 10751, 'name': 'Family'}] | [{'name': 'TriStar Pictures', 'id': 559}, {'name': 'Teitler Film', 'id': 2550}, {'name': 'Interscope Communications', 'id': 10201}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'fr', 'name': 'Français'}] | en | When siblings Judy and Peter discover an enchanted board game that opens the door to a magical world, they unwittingly invite Alan -- an adult who's been trapped inside the game for 26 years -- into their living room. Alan's only hope for freedom is to finish the game, which proves risky as all three find themselves running from giant rhinoceroses, evil monkeys and other terrifying creatures. | 17.015539 | 6.9 | 2413.0 | NaN | Released | 4.04 |
| 2 | 15602 | Grumpier Old Men | Still Yelling. Still Fighting. Still Ready for Love. | 1995-12-22 | 1995 | 101.0 | 0 | 0 | [{'id': 10749, 'name': 'Romance'}, {'id': 35, 'name': 'Comedy'}] | [{'name': 'Warner Bros.', 'id': 6194}, {'name': 'Lancaster Gate', 'id': 19464}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | A family wedding reignites the ancient feud between next-door neighbors and fishing buddies John and Max. Meanwhile, a sultry Italian divorcée opens a restaurant at the local bait shop, alarming the locals who worry she'll scare the fish away. But she's less interested in seafood than she is in cooking up a hot time with Max. | 11.712900 | 6.5 | 92.0 | {'id': 119050, 'name': 'Grumpy Old Men Collection', 'poster_path': '/nLvUdqgPgm3F85NMCii9gVFUcet.jpg', 'backdrop_path': '/hypTnLot2z8wpFS7qwsQHW1uV8u.jpg'} | Released | 0.00 |
| 3 | 31357 | Waiting to Exhale | Friends are the people who let you be yourself... and never let you forget it. | 1995-12-22 | 1995 | 127.0 | 16000000 | 81452156 | [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'name': 'Drama'}, {'id': 10749, 'name': 'Romance'}] | [{'name': 'Twentieth Century Fox Film Corporation', 'id': 306}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | Cheated on, mistreated and stepped on, the women are holding their breath, waiting for the elusive "good man" to break a string of less-than-stellar lovers. Friends and confidants Vannah, Bernie, Glo and Robin talk it all out, determined to find a better way to breathe. | 3.859495 | 6.1 | 34.0 | NaN | Released | 5.09 |
| 4 | 11862 | Father of the Bride Part II | Just When His World Is Back To Normal... He's In For The Surprise Of His Life! | 1995-02-10 | 1995 | 106.0 | 0 | 76578911 | [{'id': 35, 'name': 'Comedy'}] | [{'name': 'Sandollar Productions', 'id': 5842}, {'name': 'Touchstone Pictures', 'id': 9195}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | Just when George Banks has recovered from his daughter's wedding, he receives the news that she's pregnant ... and that George's wife, Nina, is expecting too. He was planning on selling their home, but that's a plan that -- like George -- will have to change with the arrival of both a grandchild and a kid of his own. | 8.387519 | 5.7 | 173.0 | {'id': 96871, 'name': 'Father of the Bride Collection', 'poster_path': '/nts4iOmNnq7GNicycMJ9pSAn204.jpg', 'backdrop_path': '/7qwE57OVZmMJChBpLEbJEmzUydk.jpg'} | Released | 0.00 |
| 5 | 949 | Heat | A Los Angeles Crime Saga | 1995-12-15 | 1995 | 170.0 | 60000000 | 187436818 | [{'id': 28, 'name': 'Action'}, {'id': 80, 'name': 'Crime'}, {'id': 18, 'name': 'Drama'}, {'id': 53, 'name': 'Thriller'}] | [{'name': 'Regency Enterprises', 'id': 508}, {'name': 'Forward Pass', 'id': 675}, {'name': 'Warner Bros.', 'id': 6194}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'es', 'name': 'Español'}] | en | Obsessive master thief, Neil McCauley leads a top-notch crew on various insane heists throughout Los Angeles while a mentally unstable detective, Vincent Hanna pursues him without rest. Each man recognizes and respects the ability and the dedication of the other even though they are aware their cat-and-mouse game may end in violence. | 17.924927 | 7.7 | 1886.0 | NaN | Released | 3.12 |
| 6 | 11860 | Sabrina | You are cordially invited to the most surprising merger of the year. | 1995-12-15 | 1995 | 127.0 | 58000000 | 0 | [{'id': 35, 'name': 'Comedy'}, {'id': 10749, 'name': 'Romance'}] | [{'name': 'Paramount Pictures', 'id': 4}, {'name': 'Scott Rudin Productions', 'id': 258}, {'name': 'Mirage Enterprises', 'id': 932}, {'name': 'Sandollar Productions', 'id': 5842}, {'name': 'Constellation Entertainment', 'id': 14941}, {'name': 'Worldwide', 'id': 55873}, {'name': 'Mont Blanc Entertainment GmbH', 'id': 58079}] | [{'iso_3166_1': 'DE', 'name': 'Germany'}, {'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'fr', 'name': 'Français'}, {'iso_639_1': 'en', 'name': 'English'}] | en | An ugly duckling having undergone a remarkable change, still harbors feelings for her crush: a carefree playboy, but not before his business-focused brother has something to say about it. | 6.677277 | 6.2 | 141.0 | NaN | Released | 0.00 |
| 7 | 45325 | Tom and Huck | The Original Bad Boys. | 1995-12-22 | 1995 | 97.0 | 0 | 0 | [{'id': 28, 'name': 'Action'}, {'id': 12, 'name': 'Adventure'}, {'id': 18, 'name': 'Drama'}, {'id': 10751, 'name': 'Family'}] | [{'name': 'Walt Disney Pictures', 'id': 2}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'de', 'name': 'Deutsch'}] | en | A mischievous young boy, Tom Sawyer, witnesses a murder by the deadly Injun Joe. Tom becomes friends with Huckleberry Finn, a boy with no future and no family. Tom has to choose between honoring a friendship or honoring an oath because the town alcoholic is accused of the murder. Tom and Huck go through several adventures trying to retrieve evidence. | 2.561161 | 5.4 | 45.0 | NaN | Released | 0.00 |
| 8 | 9091 | Sudden Death | Terror goes into overtime. | 1995-12-22 | 1995 | 106.0 | 35000000 | 64350171 | [{'id': 28, 'name': 'Action'}, {'id': 12, 'name': 'Adventure'}, {'id': 53, 'name': 'Thriller'}] | [{'name': 'Universal Pictures', 'id': 33}, {'name': 'Imperial Entertainment', 'id': 21437}, {'name': 'Signature Entertainment', 'id': 23770}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | International action superstar Jean Claude Van Damme teams with Powers Boothe in a Tension-packed, suspense thriller, set against the back-drop of a Stanley Cup game.Van Damme portrays a father whose daughter is suddenly taken during a championship hockey game. With the captors demanding a billion dollars by game's end, Van Damme frantically sets a plan in motion to rescue his daughter and abort an impending explosion before the final buzzer... | 5.231580 | 5.5 | 174.0 | NaN | Released | 1.84 |
| 9 | 710 | GoldenEye | No limits. No fears. No substitutes. | 1995-11-16 | 1995 | 130.0 | 58000000 | 352194034 | [{'id': 12, 'name': 'Adventure'}, {'id': 28, 'name': 'Action'}, {'id': 53, 'name': 'Thriller'}] | [{'name': 'United Artists', 'id': 60}, {'name': 'Eon Productions', 'id': 7576}] | [{'iso_3166_1': 'GB', 'name': 'United Kingdom'}, {'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'ru', 'name': 'Pусский'}, {'iso_639_1': 'es', 'name': 'Español'}] | en | James Bond must unmask the mysterious head of the Janus Syndicate and prevent the leader from utilizing the GoldenEye weapons system to inflict devastating revenge on Britain. | 14.686036 | 6.6 | 1194.0 | {'id': 645, 'name': 'James Bond Collection', 'poster_path': '/HORpg5CSkmeQlAolx3bKMrKgfi.jpg', 'backdrop_path': '/6VcVl48kNKvdXOZfJPdarlUGOsk.jpg'} | Released | 6.07 |
| movie_id | title | tagline | release_date | release_year | runtime | budget | revenue | genres | production_companies | production_countries | spoken_languages | original_language | overview | popularity | vote_average | vote_count | belongs_to_collection | status | return | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45366 | 67179 | St. Michael Had a Rooster | nan | 1972-01-01 | 1972 | 90.0 | 0 | 0 | [] | [] | [] | [{'iso_639_1': 'it', 'name': 'Italiano'}] | it | Sentenced to life imprisonment for illegal activities, Italian International member Giulio Manieri holds on to his political ideals while struggling against madness in the loneliness of his prison cell. | 0.225051 | 6.0 | 3.0 | NaN | Released | 0.0 |
| 45367 | 84419 | House of Horrors | Meet...The CREEPER! | 1946-03-29 | 1946 | 65.0 | 0 | 0 | [{'id': 27, 'name': 'Horror'}, {'id': 9648, 'name': 'Mystery'}, {'id': 53, 'name': 'Thriller'}] | [{'name': 'Universal Pictures', 'id': 33}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | An unsuccessful sculptor saves a madman named "The Creeper" from drowning. Seeing an opportunity for revenge, he tricks the psycho into murdering his critics. | 0.222814 | 6.3 | 8.0 | NaN | Released | 0.0 |
| 45368 | 390959 | Shadow of the Blair Witch | nan | 2000-10-22 | 2000 | 45.0 | 0 | 0 | [{'id': 9648, 'name': 'Mystery'}, {'id': 27, 'name': 'Horror'}] | [] | [] | [{'iso_639_1': 'en', 'name': 'English'}] | en | In this true-crime documentary, we delve into the murder spree that was the inspiration for Joe Berlinger's "Book of Shadows: Blair Witch 2". | 0.076061 | 7.0 | 2.0 | NaN | Released | 0.0 |
| 45369 | 289923 | The Burkittsville 7 | Do you know what happened 50 years before "The Blair Witch Project"? | 2000-10-03 | 2000 | 30.0 | 0 | 0 | [{'id': 27, 'name': 'Horror'}] | [{'name': 'Neptune Salad Entertainment', 'id': 27570}, {'name': 'Pirie Productions', 'id': 27571}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | A film archivist revisits the story of Rustin Parr, a hermit thought to have murdered seven children while under the possession of the Blair Witch. | 0.386450 | 7.0 | 1.0 | NaN | Released | 0.0 |
| 45370 | 222848 | Caged Heat 3000 | nan | 1995-01-01 | 1995 | 85.0 | 0 | 0 | [{'id': 878, 'name': 'Science Fiction'}] | [{'name': 'Concorde-New Horizons', 'id': 4688}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | It's the year 3000 AD. The world's most dangerous women are banished to a remote asteroid 45 million light years from earth. Kira Murphy doesn't belong; wrongfully accused of a crime she did not commit, she's thrown in this interplanetary prison and left to her own defenses. But Kira's a fighter, and soon she finds herself in the middle of a female gang war; where everyone wants a piece of the action... and a piece of her! "Caged Heat 3000" takes the Women-in-Prison genre to a whole new level... and a whole new galaxy! | 0.661558 | 3.5 | 1.0 | NaN | Released | 0.0 |
| 45371 | 30840 | Robin Hood | nan | 1991-05-13 | 1991 | 104.0 | 0 | 0 | [{'id': 18, 'name': 'Drama'}, {'id': 28, 'name': 'Action'}, {'id': 10749, 'name': 'Romance'}] | [{'name': 'Westdeutscher Rundfunk (WDR)', 'id': 7025}, {'name': 'Working Title Films', 'id': 10163}, {'name': '20th Century Fox Television', 'id': 16323}, {'name': 'CanWest Global Communications', 'id': 38978}] | [{'iso_3166_1': 'CA', 'name': 'Canada'}, {'iso_3166_1': 'DE', 'name': 'Germany'}, {'iso_3166_1': 'GB', 'name': 'United Kingdom'}, {'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | Yet another version of the classic epic, with enough variation to make it interesting. The story is the same, but some of the characters are quite different from the usual, in particular Uma Thurman's very special maid Marian. The photography is also great, giving the story a somewhat darker tone. | 5.683753 | 5.7 | 26.0 | NaN | Released | 0.0 |
| 45372 | 111109 | Century of Birthing | nan | 2011-11-17 | 2011 | 360.0 | 0 | 0 | [{'id': 18, 'name': 'Drama'}] | [{'name': 'Sine Olivia', 'id': 19653}] | [{'iso_3166_1': 'PH', 'name': 'Philippines'}] | [{'iso_639_1': 'tl', 'name': ''}] | tl | An artist struggles to finish his work while a storyline about a cult plays in his head. | 0.178241 | 9.0 | 3.0 | NaN | Released | 0.0 |
| 45373 | 67758 | Betrayal | A deadly game of wits. | 2003-08-01 | 2003 | 90.0 | 0 | 0 | [{'id': 28, 'name': 'Action'}, {'id': 18, 'name': 'Drama'}, {'id': 53, 'name': 'Thriller'}] | [{'name': 'American World Pictures', 'id': 6165}] | [{'iso_3166_1': 'US', 'name': 'United States of America'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | When one of her hits goes wrong, a professional assassin ends up with a suitcase full of a million dollars belonging to a mob boss ... | 0.903007 | 3.8 | 6.0 | NaN | Released | 0.0 |
| 45374 | 227506 | Satan Triumphant | nan | 1917-10-21 | 1917 | 87.0 | 0 | 0 | [] | [{'name': 'Yermoliev', 'id': 88753}] | [{'iso_3166_1': 'RU', 'name': 'Russia'}] | [] | en | In a small town live two brothers, one a minister and the other one a hunchback painter of the chapel who lives with his wife. One dreadful and stormy night, a stranger knocks at the door asking for shelter. The stranger talks about all the good things of the earthly life the minister is missing because of his puritanical faith. The minister comes to accept the stranger's viewpoint but it is others who will pay the consequences because the minister will discover the human pleasures thanks to, ehem, his sister- in -law… The tormented minister and his cuckolded brother will die in a strange accident in the chapel and later an infant will be born from the minister's adulterous relationship. | 0.003503 | 0.0 | 0.0 | NaN | Released | 0.0 |
| 45375 | 461257 | Queerama | nan | 2017-06-09 | 2017 | 75.0 | 0 | 0 | [] | [] | [{'iso_3166_1': 'GB', 'name': 'United Kingdom'}] | [{'iso_639_1': 'en', 'name': 'English'}] | en | 50 years after decriminalisation of homosexuality in the UK, director Daisy Asquith mines the jewels of the BFI archive to take us into the relationships, desires, fears and expressions of gay men and women in the 20th century. | 0.163015 | 0.0 | 0.0 | NaN | Released | 0.0 |
Duplicate rows
Most frequently occurring
| movie_id | title | tagline | release_date | release_year | runtime | budget | revenue | original_language | overview | popularity | vote_average | vote_count | status | return | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 141971 | Blackout | Which one is the first to return - memory or the murderer? | 2008-12-26 | 2008 | 108.0 | 0 | 0 | fi | Recovering from a nail gun shot to the head and 13 months of coma, doctor Pekka Valinta starts to unravel the mystery of his past, still suffering from total amnesia. | 0.411949 | 6.7 | 3.0 | Released | 0.0 | 3 |
| 0 | 5511 | Le Samouraï | There is no solitude greater than that of the Samurai | 1967-10-25 | 1967 | 105.0 | 0 | 39481 | fr | Hitman Jef Costello is a perfectionist who always carefully plans his murders and who never gets caught. | 9.091288 | 7.9 | 187.0 | Released | 0.0 | 2 |
| 1 | 11115 | Deal | nan | 2008-01-29 | 2008 | 85.0 | 0 | 0 | en | As an ex-gambler teaches a hot-shot college kid some things about playing cards, he finds himself pulled into the world series of poker, where his protégé is his toughest competition. | 6.880365 | 5.2 | 22.0 | Released | 0.0 | 2 |
| 2 | 18440 | Days of Darkness | nan | 2007-01-01 | 2007 | 89.0 | 0 | 0 | en | When a comet strikes Earth and kicks up a cloud of toxic dust, hundreds of humans join the ranks of the living dead. But there's bad news for the survivors: The newly minted zombies are hell-bent on eradicating every last person from the planet. For the few human beings who remain, going head to head with the flesh-eating fiends is their only chance for long-term survival. Yet their battle will be dark and cold, with overwhelming odds. | 1.436085 | 5.0 | 5.0 | Released | 0.0 | 2 |
| 3 | 23305 | The Warrior | nan | 2001-09-23 | 2001 | 86.0 | 0 | 0 | en | In feudal India, a warrior (Khan) who renounces his role as the longtime enforcer to a local lord becomes the prey in a murderous hunt through the Himalayan mountains. | 1.967992 | 6.3 | 15.0 | Released | 0.0 | 2 |
| 4 | 25541 | Brotherhood | nan | 2009-10-21 | 2009 | 90.0 | 0 | 0 | da | Former Danish servicemen Lars and Jimmy are thrown together while training in a neo-Nazi group. Moving from hostility through grudging admiration to friendship and finally passion, events take a darker turn when their illicit relationship is uncovered. | 2.587911 | 7.1 | 21.0 | Released | 0.0 | 2 |
| 5 | 42495 | King Lear | nan | 1971-02-04 | 1971 | 137.0 | 0 | 0 | en | King Lear, old and tired, divides his kingdom among his daughters, giving great importance to their protestations of love for him. When Cordelia, youngest and most honest, refuses to idly flatter the old man in return for favor, he banishes her and turns for support to his remaining daughters. But Goneril and Regan have no love for him and instead plot to take all his power from him. In a parallel, Lear's loyal courtier Gloucester favors his illegitimate son Edmund after being told lies about his faithful son Edgar. Madness and tragedy befall both ill-starred fathers. | 0.187901 | 8.0 | 3.0 | Rumored | 0.0 | 2 |
| 6 | 97995 | Seven Years Bad Luck | nan | 1921-02-06 | 1921 | 62.0 | 0 | 0 | en | After breaking a mirror in his home, superstitious Max tries to avoid situations which could bring bad luck but in doing so, causes himself the worst luck imaginable. | 0.141558 | 5.6 | 4.0 | Released | 0.0 | 2 |
| 7 | 99080 | The Viking | Actually produced during the Great Newfoundland Seal Hunt and You see the REAL thing | 1931-06-21 | 1931 | 70.0 | 0 | 0 | en | Originally called White Thunder, American producer Varick Frissell's 1931 film was inspired by his love for the Canadian Arctic Circle. Set in a beautifully black-and-white filmed Newfoundland, it is the story of a rivalry between two seal hunters that plays out on the ice floes during a hunt. Unsatisfied with the first cut, Frissell arranged for the crew to accompany an actual Newfoundland seal hunt on The SS Viking, on which an explosion of dynamite (carried regularly at the time on Arctic ships to combat ice jams) killed many members of the crew, including Frissell. The film was renamed in honor of the dead. | 0.002362 | 0.0 | 0.0 | Released | 0.0 | 2 |
| 8 | 105045 | The Promise | A love, a hope, a wall. | 1995-02-16 | 1995 | 115.0 | 0 | 0 | de | East-Berlin, 1961, shortly after the erection of the Wall. Konrad, Sophie and three of their friends plan a daring escape to Western Germany. The attempt is successful, except for Konrad, who remains behind. From then on, and for the next 28 years, Konrad and Sophie will attempt to meet again, in spite of the Iron Curtain. Konrad, who has become a reputed Astrophysicist, tries to take advantage of scientific congresses outside Eastern Germany to arrange encounters with Sophie. But in a country where the political police, the Stasi, monitors the moves of all suspicious people (such as Konrad's sister Barbara and her husband Harald), preserving one's privacy, ideals and self-respect becomes an exhausting fight, even as the Eastern block begins its long process of disintegration. | 0.122178 | 5.0 | 1.0 | Released | 0.0 | 2 |